/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50513
 Source Host           : localhost
 Source Database       : ng

 Target Server Version : 50513
 File Encoding         : utf-8

 Date: 07/13/2011 21:58:37 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `real_estate_property`
-- ----------------------------
DROP TABLE IF EXISTS `real_estate_property`;
CREATE TABLE `real_estate_property` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `street_id` int(11) NOT NULL,
  `street_number` varchar(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `type` smallint(6) NOT NULL,
  `bedroom` smallint(6) NOT NULL,
  `ensuite` smallint(6) NOT NULL,
  `bathroom` smallint(6) NOT NULL,
  `car_space` smallint(6) NOT NULL,
  `land_area` int(11) NOT NULL,
  `floor_area` int(11) NOT NULL,
  `primary_use` smallint(6) NOT NULL,
  `lga` varchar(255) NOT NULL,
  `lot_plan` varchar(255) NOT NULL,
  `zone_code` smallint(6) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `tags` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `real_estate_property_539ecf1b` (`street_id`),
  KEY `real_estate_property_5d9b2108` (`tags`),
  CONSTRAINT `street_id_refs_id_91196198` FOREIGN KEY (`street_id`) REFERENCES `location_street` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `real_estate_property`
-- ----------------------------
BEGIN;
INSERT INTO `real_estate_property` VALUES
('1', '1', '1', '1', '0', '4', '2', '2', '2', '430', '300', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('2', '1', '7/8', '2', '1', '3', '1', '2', '1', '180', '180', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('3', '1', '10/8', '3', '1', '3', '1', '2', '1', '150', '180', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('4', '1', '12/8', '4', '1', '3', '1', '2', '1', '165', '180', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('5', '1', '10', '5', '0', '4', '2', '4', '2', '530', '350', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('6', '1', '6', '6', '0', '5', '3', '4', '3', '680', '400', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('7', '1', '4', '7', '0', '4', '2', '3', '2', '600', '320', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('8', '2', '104', '8', '2', '0', '0', '2', '5', '200', '200', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('9', '2', '150', '9', '2', '0', '0', '2', '6', '300', '300', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('10', '2', '400', '10', '2', '0', '0', '2', '5', '270', '370', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('11', '2', '250', '11', '3', '0', '0', '2', '6', '400', '400', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('12', '2', '280', '12', '3', '0', '0', '2', '8', '500', '500', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('13', '2', '283', '13', '3', '0', '0', '2', '6', '500', '500', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('14', '2', '264', '14', '3', '0', '0', '2', '4', '300', '300', '1', 'lga123', 'lot_plan1', '2', '1234.567', '28.7', null),
('15', '3', '97', '15', '0', '4', '2', '3', '2', '540', '420', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('16', '3', '96', '16', '0', '4', '2', '3', '2', '700', '480', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('17', '3', '94', '17', '0', '5', '3', '4', '2', '800', '460', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('18', '3', '93', '18', '0', '5', '3', '3', '3', '890', '520', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('19', '3', '88', '19', '0', '6', '4', '4', '3', '1200', '600', '0', 'lga123', 'lot_plan1', '1', '1234.567', '28.7', null),
('20', '3', '83', '20', '5', '0', '0', '0', '0', '1500', '0', '4', 'lga123', 'lot_plan1', '3', '1234.567', '28.7', null),
('21', '3', '85', '21', '7', '0', '0', '0', '0', '1009', '0', '4', 'lga123', 'lot_plan1', '3', '1234.567', '28.7', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
